Strongly Possible Functional Dependencies for SQL
نویسندگان
چکیده
Missing data is a large-scale challenge to research and investigate. It reduces the statistical power produces negative consequences that may introduce selection bias on data. Many approaches handle this problem have been introduced. The main suggested are either missing values be ignored (removed) or imputed (filled in) with new values. This paper uses second method. Possible worlds possible certain keyswere introduced in Köhler et.al., by Levene et.al. Link functional dependencies (c-FD) as natural complement Lien's class of (p-FD). Weak strong were studied Loizou. We intermediate concept strongly obtained imputing already existing table preceding paper. results keys (spKey's) (spFD's). give polynomial algorithm verify single spKey show general, it NP-complete an arbitrary collection spKeys. graph-theoretical characterization validity given spFD X →sp Y.We show, complexity dependency then we some cases when verifying can done time.As step forward axiomatization spFD's, rules for weak checked. Appropriate weakenings those not sound spFD's listed. interaction between spKey's studied. Furthermore, graph theoretical implication singular attribute given.
منابع مشابه
Design by Example for SQL Tables with Functional Dependencies
An Armstrong relation satisfies the functional dependencies (FD) implied by a given FD set and violates all other FDs. Therefore, they form an instance of the design-by-example methodology: the example relation exhibits precisely those FDs that the current design perceives as meaningful for the application domain. The existing framework of Armstrong relations only applies to total relations. We...
متن کاملProbabilistic XML functional dependencies based on possible world model
With the increase of uncertain data in many new applications, such as sensor network, data integration, web extraction, etc., uncertainty both in relational databases and XML datasets has attracted more and more research interests in recent years. As functional dependencies (FDs) are critical and necessary to schema design and data rectification in relational databases and XML datasets, it is a...
متن کاملOn Strongly First-Order Dependencies
We prove that the expressive power of first-order logic with team semantics plus contradictory negation does not rise beyond that of first-order logic (with respect to sentences), and that the totality atoms of arity k + 1 are not definable in terms of the totality atoms of arity k. We furthermore prove that all first-order nullary and unary dependencies are strongly first order, in the sense t...
متن کاملFunctional Dependencies for XML
In this paper we address the problem of how to extend the deenition of functional dependencies (FDs) in incomplete relations to XML documents. An incomplete relation is said to strongly satisfy a FD if every completion of the relation, obtained by replacing all null values by data values, satisses the FD in the ordinary sense. We propose a syntactic deenition of strong FD satisfaction in a XML ...
متن کاملPossible and Certain SQL Key
Driven by the dominance of the relational model, the requirements of modern applications, and the veracity of data, we revisit the fundamental notion of a key in relational databases with NULLs. In SQL database systems primary key columns are NOT NULL by default. NULL columns may occur in unique constraints which only guarantee uniqueness for tuples which do not feature null markers in any of t...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Acta Cybernetica
سال: 2022
ISSN: ['2676-993X', '0324-721X']
DOI: https://doi.org/10.14232/actacyb.287523